How to: Print all or part of a workbook.
Solution:
Select 'Print...' from the 'File' menu and choose 'Selection', 'Selected Sheet(s)' or 'Entire Workbook'.
To print a workbook or part of a workbook:
1) Select the 'File' menu and select 'Print...'. (The Print dialog box appears.)
2) Do one of the following:
a) To print a selected area, select the 'Selection' radio button in the 'Print What' group.
b) To print one or multiple sheets in a workbook, select the 'Selected Sheet(s)' radio button in the 'Print What' group.
c) To print the entire workbook, select the 'Entire Workbook' radio button in the 'Print What' group.
3) Do one of the following:
a) To print the entire selection or the entire workbook, select the 'All' radio button in the 'Page Range' group.
b) To print a part of the workbook or selection (if the selection has multiple pages):
1] Select the 'Pages' radio button in the 'Page Range' group.
2] Specify the range in the 'from' and 'to' boxes.
4) Type the desired number in the 'Number of copies' box.
5) Click 'OK'.